/*
 Navicat Premium Data Transfer

 Source Server         : 127.0.0.1
 Source Server Type    : MySQL
 Source Server Version : 80032 (8.0.32)
 Source Host           : 127.0.0.1:3306
 Source Schema         : easy-demo

 Target Server Type    : MySQL
 Target Server Version : 80032 (8.0.32)
 File Encoding         : 65001

 Date: 14/06/2023 16:50:21
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '座次',
  `name` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '姓名',
  `nick_name` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '诨名',
  `constellation` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '星宿',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `del` tinyint DEFAULT '0' COMMENT '逻辑删除; 0：未删除/1：已删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='梁山好汉 109 犟';

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` (`id`, `name`, `nick_name`, `constellation`, `create_time`, `update_time`, `del`) VALUES (1, '宋江', '呼保义', '天魁星', '2023-06-14 15:23:04', '2023-06-14 15:37:58', 0);
INSERT INTO `user` (`id`, `name`, `nick_name`, `constellation`, `create_time`, `update_time`, `del`) VALUES (2, '卢俊义', '玉麒麟', '天罡星', '2023-06-14 15:23:04', NULL, 0);
INSERT INTO `user` (`id`, `name`, `nick_name`, `constellation`, `create_time`, `update_time`, `del`) VALUES (3, '吴用', '智多星', '天机星', '2023-06-14 15:23:04', NULL, 0);
INSERT INTO `user` (`id`, `name`, `nick_name`, `constellation`, `create_time`, `update_time`, `del`) VALUES (4, '公孙胜', '入云龙', '天闲星', '2023-06-14 15:23:04', NULL, 0);
INSERT INTO `user` (`id`, `name`, `nick_name`, `constellation`, `create_time`, `update_time`, `del`) VALUES (5, '关胜', '大刀', '天勇星', '2023-06-14 15:23:04', NULL, 0);
INSERT INTO `user` (`id`, `name`, `nick_name`, `constellation`, `create_time`, `update_time`, `del`) VALUES (6, '林冲', '豹子头', '天雄星', '2023-06-14 15:23:04', NULL, 0);
INSERT INTO `user` (`id`, `name`, `nick_name`, `constellation`, `create_time`, `update_time`, `del`) VALUES (7, '秦明', '霹雳火', '天猛星', '2023-06-14 15:23:04', NULL, 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
